How to: Manually calculate only the active worksheet.
Solution:
Select 'Options...' from the 'Tools' menu, click the 'Calculation' tab, and click 'Calc Sheet'.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click 'Calculation' tab.
3) Click 'Calc Now'.
The Calc Now button
